package com.fengxing.ams.web.facade.mouble.realtime;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.data.repository.query.Param;

public interface IRealtimeStudentDAO extends PagingAndSortingRepository<RealtimeStudentVO, Integer>, JpaSpecificationExecutor<RealtimeStudentVO>  {

	@Query("select t from RealtimeStudentVO t where t.apply_score > :min_score and t.apply_score < :max_score and t.clazz=:clazz order by t.apply_score desc")
	List<RealtimeStudentVO> findSchoolVO(@Param("clazz")String clazz, @Param("max_score")Integer max_score, @Param("min_score")Integer min_score);
	
}
